package com.fourth.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fourth.vo.QaiTaiSouSuo;
import com.ljx.entity.HeadNav;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UBhomeHeadNavDao extends BaseMapper<HeadNav> {

	@Select("select z.Id zoneId,b.id bid ,z.zone_name,b.sname, b.bicon,o.price,o.num sales from tb_zone z \n" +
			"LEFT OUTER JOIN tb_zone_business tb on z.id=tb.zone_id \n" +
			" LEFT OUTER JOIN b_business_info b on tb.bid=b.id  \n" +
			"\tJOIN o_order o on b.id=o.bid where b.sname like '%${name}%'  GROUP BY  b.id")
	List<QaiTaiSouSuo> findBusinessByName(String chandVal);
}
